ServiceLayer on TomEE

  1. Create a directory on the TomEE server to store various configuration files for OIPA (i.e., /tomee/shared or D:\tomee\shared).

  2. Create subdirectories inside the directory from Step 1 called conf and lib.

  3. Copy PASService-tomEE.war file from the OIPA distribution zip file into the webapps subdirectory of TomEE server (Ex : /tomee/webapps or D:\tomee\webapps).

  4. Rename the war to PASService.war.

  5. Copy the following configuration files from PASService-tomEE-distribution.zip/conf directory into the \shared\conf directory under TomEE server:

    1. service-coherence-cache-config.xml

    2. service-coherence-config.xml

    3. Configuration.properties

    4. Service.properties

    5. EDKeyValue.dat

    6. logging.properties

    7. oipakeystore.p12

  6. Copy the following files from the OIPA distribution zip/libs directory into the shared\lib directory:

    1. jakarta.persistence-api-3.2.0.jar

    2. Download aspectj 1.9.1.jar from http://www.eclipse.org/downloads/download.php?file=/tools/aspectj/aspectj-1.9.1.jar.

      • Open aspectj-1.9.1.jar with an unzipping software and retrieve aspectjrt.jar and aspectjweaver.jar from the lib folder.

      • Copy aspectjrt.jar and aspectjweaver.jar into lib sub-directory.

    3. Copy the database drivers for your database into lib directory of TomEE (%TomEE_Home%/lib folder).

      • Oracle – The necessary driver, ojdbc17-23.6.0.24.10.jar, is included in the libs directory of the OIPA Media Pack.

        Note: Version 12.2.0.0 is also supported on Oracle 19c, which is LTS (Long Term Support) and Oracle 26ai. If Oracle 19c or Oracle 26ai is used, the corresponding supported ojdbc driver version shipped with Oracle database should be used in the step above.

      • Microsoft SQL Server- Use the compatible jdbc driver shipped with MS SQL Server software. These files are not available for download. Contact your IT department if you need assistance locating these files.

      • IBM DB2 – Use the compatible jdbc driver shipped with DB2 software. These files are not available for download. Contact your IT department if you need assistance locating these files.

  • Use a text editor to open the Service.properties file that you just copied to the server. The Service.properties file contains properties for Oracle, SQL Server and DB2 database types, with the Oracle settings active by default. The inactive settings are commented out with a '#' character at the start of each line. To change a setting, remove the '#' from the required property setting, and insert it at the beginning of the setting you want to de-activate.

  • The property application.encryptDecryptFilePath should point to the EDKeyValue.dat in the shared/conf.

  • The properties setting must match the type of database being used. Refer to the OIPA System Properties document Library on the OTN for a complete list of all properties and allowed values.

    • application.databaseType

    • jpa.databasePlatform

  • The property application.encryptDecryptFilePath is deprecated and will be removed in future release. It is recommended to use application.keyStorePath and application.keyStoreAlias.

    1. application.keyStorePath - Absolute path including file name where the oipakeystore.p12 is located. Example: application.keyStorePath = /scratch/oipa/Oracle/oipa/conf/oipakeystore.p12.

    2. application.keyStoreAlias - The alias is a unique identifier for the key entry (secret key) in the keystore.Do not modify this value unless the customer rotates the encryption key.

  • Use a text editor to open the logging.properties file that you just copied to the server.

  • Edit the path mention for property "java.util.logging.FileHandler.pattern" with new application log location i.e. if application log location is /home/ServiceLayer/logs then set this value as java.util.logging.FileHandler.pattern = %h/ServiceLayer/logs/servicelayer%u.log. Also same time make sure that directory is created and has r/w permission.

  • Under conf directory of TomEE (%TomEE_Home%/conf folder), the system.properties needs to be modified to enable TomEE to load classes from com.oracle.service package on server start up. Use a text editor to open the system.properties and add the below property.

    system.properties

    openejb.classloader.forced-load=com.oracle.service